DataSetColumn(<column>) |
Array/List of data from a Column |
Returns a set of all the values in the selected column |
DataSetRow(<row>) |
Array/List of data from a Row |
Returns a set of all the values in the selected row |
RemoveBlanks([<value_set>]) |
Remove Blanks |
This will produce a value set where all the blank or null values ("Nan") have been removed from the list. Useful for when calculating things and you want to exclude null values or when the calculation doesn't work with null values. |
Sum([<value_set>]) |
Sums a list of data |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Max([<value_set>]) |
Maximum value in a list of data |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Min([<value_set>]) |
Minimum value in a list of data |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Average([<value_set>]) |
Average of values in a list |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Median([<value_set>]) |
Median of values in a list |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
StandardDeviation([<value_set>]) |
Standard Deviation of values in a list |
The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Correlation([<value_set 1>], [<value_set 2>]) |
Correlation of values in a list |
The value sets needed can be derived from the DataSetColumn or DataSetRow functions. |
Covariance([<value_set 1>], [<value_set 2>]) |
Covariance of values in a list |
The value sets needed can be derived from the DataSetColumn or DataSetRow functions. |
Rank(<value>, [<value_set>]) |
Rank of a given value as compared to other values in a list |
Requires the input of a value to rank against a set of values. The value set needed can be derived from the DataSetColumn or DataSetRow functions. The highest value is first. |
PercentileRank(<percent>, [<value_set>]) |
Gives a value represented by the percentage position within the ordered list of values provided. |
Requires the input of a percent between 0 and 1. The value set needed can be derived from the DataSetColumn or DataSetRow functions. |
Iff(<criteria>,<if_true>,<if_false>) |
‘If’ conditional logic |
This is used to build a decision within the result of the formulation |
Case(new bool[]{<criteria_set>}, new[]{<outcome_set>},<default_value>) |
‘Case’ conditional logic |
This is used to build a decision within the result of the formulation. Here the index of the criteria should match with the index of the outcome. |
IsNan(<value>) |
Checks for null "double" value or "Nan" |
This will return true if the input value is a null value. Since the values are numeric 'doubles', the null is returned as a "Nan". |